Aside

Michael Hanna

Contact Info

Personal Statement

My engineering background, operational experience, and strong computer skills provide a deep understanding of business needs and data flows that allow me to produce user-friendly and efficient solutions that cover the whole data life cycle from data capture, quality control, and extraction to data manipulation, visualization, and analysis.

Skills

  • Proficient with SQL Scripting
  • Proficient with TIBCO Spotfire
  • Proficient with Excel and VBA Programming

Main

Michael Hanna

Data Engineer leveraging 15 years of high-pressure operational experience in the energy sector looking to deliver value to a new industry and organization. Please check my cover letter here!

Professional Experience

Data Engineer

EQT Corporation

Pittsburgh, PA

Jun 2017 - Current

  • Write R and SQL scripts to Extract, Transform, and Load data (ETL) from the authoritative sources to enable data-driven decisions for the business.
  • Create Data Pipelines using R, Azure Data Factory, and Informatica Cloud.
  • Develop insights using Tibco Spotfire, Microsoft Power BI, and R Shiny apps as needed.
  • Report quarterly drilling performance and KPIs to the management.
  • Create and deploy all Wellview drilling data audits to ensure data reliability.
  • Manage work using cases and work items in Salesforce and repositories in Github.

Wells Performance Analyst

BP

Anchorage, Alaska

Apr 2012 - May 2017

  • Develop Excel automated tools using VBA for end of well reporting, wellbore integrity testing calculator, well scorecard, and data quality audits.
  • Provide support to the drilling and workover teams by responding to ad-hoc data requests, answering questions, and providing analysis.
  • Act as Landmark applications point of contact for OpenWells, Compass, and Data Analyzer.
  • Create and maintain GWO (Global Wells Organization) Spotfire interactive dashboards.
  • Compile and manipulate data from different sources to assist with technical analysis (EDM, AWGRS, Finder, SAP Business Objects,…etc.)
  • Assist in Drilling Performance Benchmarking and KPIs.
  • Update the company legacy tools to comply with the new policies and best practices.
  • Participate in testing of Landmark new software releases and provide acceptance criteria to the management.

Senior Drilling Data Management Engineer

MCS Freezone (Modern Computing Services)

Cairo, Egypt

Mar 2006 - Sep 2011

  • Research, gather requirements, design, install, configure, troubleshoot, train, and support MCS drilling applications.
  • Report the Drilling Performance, NPT, root cause analysis, and learning curve management.
  • Support data acquisition, data entry, data quality control, and end of well reporting.
  • Implement the first Kongsberg real-time drilling data management system in the Egyptian market.
  • Install and run PMAC sand monitoring system on an offshore rig in Mauritania.
  • Manage and supervise three of MCS Junior Drilling Engineers

DRILLING APPS

  • Proficient with Landmark EDM Suite (OpenWells, Compass, Data Analyzer, and Profile)

  • Proficient with Peloton Wellview

  • Proficient with Petrobeacon Spotlight Audit App

  • Proficient with Genesis Analyzer, Designer and Data Entry System (DES)

  • Proficient with the Drilling Performance KPIs and End of Well Reporting


SKILLS ACTIVELY LEARNING

  • Python
  • Azure Data Factory, Data Lake, and Databricks
  • Power BI and DAX Language
  • R (purrr, timevis, leaflet, zoo, and data.table)

REFERENCES

Scan this barcode with your iPhone camera to look at recommendations on my LinkedIn profile.
Additional references are available upon request.


This resume was created using the R package pagedown.

Last updated on 2020-05-26

Roughneck

Global SantaFE Corporation, Offshore Key Manhattan Jackup Rig

Port Said, Egypt

Nov 2004 - Feb 2006

Education

Cairo University - Faculty of Engineering

B.Sc. in Petroleum Engineering

Cairo, Egypt

1998 - 2003

Official Credential Evaluation Report from IERF (International Education Research Foundation) - a member of NACES (National Association of Credential Evaluation Services) is available upon request.

Selected achievements

EQT

N/A

N/A

N/A

  • Developed ‘write_2_azure’ function in R to QC the written data frames prior to truncating existing tables by adding proper error handling techniques and logging the errors in the relevant database. This prevented erroneous data to be fed downstream and improved the stability of our scripts. The function was later promoted in the company package for the general consumption.
  • Automated weekly emails pulling data from Azure SQL database and sending them to joint-venture partners using R.
  • Created a Drilling Sandbox, which is a self-service Spotfire dashboard that allows the user to easily tweak a number of desired inputs and axes to answer thousands of different operational performance questions used for internal and external corporate communications, but which used to take hours to answer and verify prior to this tool’s implementation.

BP

N/A

N/A

N/A

  • Developed and maintained the first Spotfire dashboards in GWO Alaska. Received global recognition from BP.
  • Created “Wellbore Integrity Testing Criteria Calculator” which determines if the test pressure results meet the acceptance criteria according to “BP Site Technical Practice CRT-AK-10-45: Working with Pressure”.
  • Created the Drilling Data Reporter (DDR) which is a fully automated Excel tool that pulls data from EDM oracle database and generates several performance and data quality reports.

EGYPT

N/A

N/A

N/A

  • Awarded a certificate for my successful participation in the “In-House SPE Student Technical Paper Contest”, Cairo, Egypt, 2003.